package com.mengjian.myspringai.model;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;
import lombok.ToString;

import java.io.Serializable;
import java.math.BigDecimal;

/**
 * @author xieren
 * created by 2025/7/3
 */
@Data
@ToString
public class ShipData implements Serializable {
    @ExcelProperty("订单编号")
    @ColumnWidth(20)
    private String orderCode;

    @ExcelProperty("NCC采购订单编号")
    @ColumnWidth(20)
    private String nccOrderCode;

    @ExcelProperty("销售订单编号")
    @ColumnWidth(20)
    private String sellOrderCode;

    @ExcelProperty("版本类型")
    @ColumnWidth(20)
    private String versionType;

    @ExcelProperty("品牌")
    @ColumnWidth(20)
    private String brandName;

    @ExcelProperty("产成品名称")
    @ColumnWidth(20)
    private String endProductName;

    @ExcelProperty("商品名称")
    @ColumnWidth(20)
    private String goodsName;

    @ExcelProperty("规格")
    @ColumnWidth(20)
    private String specification;

    @ExcelProperty("区域经理")
    @ColumnWidth(20)
    private String serviceManager;

    @ExcelProperty("采购商名称")
    @ColumnWidth(20)
    private String customer;

    @ExcelProperty("供应商名称")
    @ColumnWidth(20)
    private String vendorName;

    @ExcelProperty("数量")
    @ColumnWidth(20)
    private BigDecimal quantity;

    @ExcelProperty("下单时间")
    @ColumnWidth(20)
    private String orderTime;

    @ExcelProperty("预计交期")
    @ColumnWidth(20)
    private String deliveryDate;

    @ExcelProperty("订单状态")
    @ColumnWidth(20)
    private String orderStatus;

    @ExcelProperty("分批发货情况")
    @ColumnWidth(20)
    private String shipBatch;

    @ExcelProperty("发货时间")
    @ColumnWidth(20)
    private String shipTime;

    @ExcelProperty("发货数量")
    @ColumnWidth(20)
    private BigDecimal shipQuantity = BigDecimal.ZERO;

    @ExcelProperty("交期天数")
    @ColumnWidth(20)
    private String deliveryDays;

    @ExcelProperty("足额率")
    @ColumnWidth(20)
    private String ratio;

    @ExcelProperty("交期达成率")
    @ColumnWidth(20)
    private String deliveryStatus;


}
